<style type="text/css">
body {
	background-color: #006400;
}
body,td,th {
	color: #F5F5DC;
}
</style>

<?php
$con = mysql_connect("localhost","root","1234");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("northwindDB", $con);




$result = mysql_query("SELECT * FROM  nwemployees " );
echo '<center>' ;
  echo  '<br><h1>Employees</h1><hr><br>';
  echo '<table width="200" border="1">';
  echo '<tr><td bgcolor="#000000">' . 'EmployeeID'. '</td>';
  echo '<td bgcolor="#000000">' . 'LastName'. '</td>';
  echo '<td bgcolor="#000000">' . 'FirstName'. '</td>';
  echo '<td bgcolor="#000000">' . 'Title'. '</td>';
  echo '<td bgcolor="#000000">' . 'TitleOfCourtesy'. '</td>';
  echo '<td bgcolor="#000000">' . 'BirthDate'. '</td>';
  echo '<td bgcolor="#000000">' . 'HireDate'. '</td>';
  echo '<td bgcolor="#000000">' . 'Address'. '</td>';
  echo '<td bgcolor="#000000">' . 'City'. '</td>';
  echo '<td bgcolor="#000000">' . 'Region'. '</td>';
  echo '<td bgcolor="#000000">' . 'PostalCode'. '</td>';
  echo '<td bgcolor="#000000">' . 'Country'. '</td>';
  echo '<td bgcolor="#000000">' . 'HomePhone'. '</td>';
  echo '<td bgcolor="#000000">' . 'Extension'. '</td>';
  echo '<td bgcolor="#000000">' . 'Notes'. '</td>';
  echo '<td bgcolor="#000000">' . 'ReportsTo'. '</td>';
  echo '<td bgcolor="#000000">' . 'PhotoFileName'. '</td></tr>';
  

while($row = mysql_fetch_array($result))
  {
  echo '<tr><td bgcolor="#999999">' .  $row['EmployeeID'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['LastName'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['FirstName'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['Title'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['TitleOfCourtesy'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['BirthDate'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['HireDate'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['Address'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['City'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['Region'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['PostalCode'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['Country'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['HomePhone'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['Extension'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['Notes'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['ReportsTo'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['PhotoFileName'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['Region'] . '</td></tr>';
  //echo "<br />";

  }
  echo '</table>';
  echo '</center>' ;
mysql_close($con);
?>